Shrink Files
Description
The plugin is designed to shrink the size of the data and log files in the specified database of SQL server.
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step Name | Name of the step. This name has to be unique in a single workflow. |
| Connection: | ||
| 2 | Server Name | The Hostname/Server Name/IP of the MSSQL Server. This field is mandatory. Drop down is available. |
| 3 | Instance name | The instance name of MSSQL Server instance. One of the two fields Instance name or Port is mandatory. Only variables/static values are allowed. |
| 4 | Port | The port number of the MSSQL server should be provided. If we provide Port number, there is no need to provide Instance name. Port number should only be an integer. |
| 5 | Username | A username of the MSSQL Server. This field is mandatory. |
| Password | ||
| 6 | Password | Specify or select the password, as required. If the checkbox Accept Value as variable/static is selected, then the password field appears as a text box and accepts static or variable values. OR If the checkbox Accept Value as variable/static is not selected, then the password field appears as a dropdown in which you can select a field from the previous steps. |
| 7 | Other Connection Parameter | Specify multiple, semi-colon separated parameters other than the default connection parameters. Other connection parameters will be appended to the default connection parameters. Example of default connection parameters: Server Name, Password. Examples of other connection parameters: encrypt=false;trustServerCertificate=false |
| Button | ||
| 8 | Test Connection | Verifies whether the connection is established or not. NOTE: Test Connection button does not work for previous step fields. Test Connection button only works with static values and environment variables. |
| Input Fields | ||
| 1 | Database | Name of the Database for which data or log file is to be shrinked. Field value is to be selected from the prompt by clicking on the Select database button. |
| 2 | Select database | Clicking on this button brings a dialog for the available databases on that particular SQL server instance. |
| 3 | File type | Type of the files to be deleted of a particular database i.e. Data files, Log files must be selected. |
| 4 | File name | Name of the file to be shrinked must be selected. Field value is to be selected from the prompt by clicking on the Select file button. |
| 5 | Select file | Clicking on this button brings a dialog for the available files of a particular database. |
| Output Fields | ||
| 1 | Result | Output field to hold the result of the successful plugin execution. This field is mandatory. For Error Handling: Refer Error Handling |